package com.a918.dao;

import com.a918.entity.Orgdaily;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface OrgdailyMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Orgdaily record);

    int insertSelective(Orgdaily record);

    Orgdaily selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Orgdaily record);

    int updateByPrimaryKey(Orgdaily record);

    Orgdaily getByNameAndDate(String wangdian, String date);

    List<Orgdaily> getByNameAndDateRange(String wangdian, String dateBgn, String dateEnd);

    Double getAvgDeliveryOfMonth(String wangdian, String startDate, String endDate);

    Integer getTotalDeliveryCountOfMonth(String wangdian, String startDate, String endDate);

}